Navicat provides Server User to add, duplicate, edit, delete users/roles, grant/revoke server permissions and permissions on the selected database objects. The object pane displays all the users/roles that exist in the server.
The SQL Server sa log in is a server-level principal. By default, it is created when an instance is installed. In SQL Server 2005 or above, the default database of sa is master. This is a change of behavior from earlier versions of SQL Server.
By default, the database includes a guest user when a database is created. Permissions granted to the guest user are inherited by users who do not have a user account in the database. The guest user cannot be dropped, but it can be disabled by revoking its CONNECT permission. The CONNECT permission can be revoked by executing REVOKE CONNECT FROM GUEST within any database other than master or tempdb.
Manage Login
Just simply click -> Server Login to open an object pane for Server Login. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete login.
Add Server Login
To add a new login
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Server Login to open the Server Login showing the login list.
- Click the
from the object pane toolbar or control-click and select New Server Login from the popup menu.
- Edit login properties and permissions on the appropriate tabs of the Server Login Designer.
To create a new login with modification as one of the existing logins
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Server Login to open the Server Login showing the login list.
- Select a login to edit in the object pane.
- control-click the login and select Duplicate Server Login from the popup menu.
- Edit login properties and privileges on the appropriate tabs of the Server Login Designer.
Edit Server Login
To edit an existing login
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Server Login to open the Server Login showing the login list.
- Select a login to edit in the object pane.
- Click the
from the object pane toolbar or control-click the login and select Design Server Login from the popup menu.
- Edit login properties and permissions on the appropriate tabs of the Server Login Designer.
Delete Server Login
To delete a login
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Server Login to open the Server Login showing the login list.
- Select a login to delete in the object pane.
- Click the
from the object pane toolbar or control-click the login and select Delete Server Login from the popup menu.
- Confirm deleting in the dialog window.
Manage Server Role
To edit an existing server role
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Server Role to open the Server Role showing the server role list.
- Select a server role to edit in the object pane.
- Click the
from the object pane toolbar or control-click the server role and select Design Server Role from the popup menu.
- Edit server role properties and permissions on the appropriate tabs of the Server Role Designer.
Manage Database User
Just simply click -> Database User to open an object pane for Database User. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete database users.
Add Database User
To add a new database user
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Database User to open the Database User showing the database user list.
- Click the
from the object pane toolbar or control-click and select New Database User from the popup menu.
- Edit database user properties and permissions on the appropriate tabs of the Database User Designer.
To create a new database user with modification as one of the existing database users
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Database User to open the Database User showing the database user list.
- Select a database user to edit in the object pane.
- Control-click the database user and select Duplicate Database User from the popup menu.
- Edit database user properties and privileges on the appropriate tabs of the Database User Designer.
Edit Database User
To edit an existing database user
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Database User to open the Database User showing the database user list.
- Select a database user to edit in the object pane.
- Click the
from the object pane toolbar or control-click the database user and select Design Database User from the popup menu.
- Edit database user properties and permissions on the appropriate tabs of the Database User Designer.
Delete Database User
To delete a database user
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Database User to open the Database User showing the database user list.
- Select a database user to delete in the object pane.
- Click the
from the object pane toolbar or control-click the database user and select Delete Database User from the popup menu.
- Confirm deleting in the dialog window.
Manage Database Role
Just simply click -> Database Role to open an object pane for Database Role. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete database roles.
Add Database Role
To add a new database role
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Database Role to open the Database Role showing the database role list.
- Click the
from the object pane toolbar or control-click and select New Database Role from the popup menu.
- Edit database role properties and permissions on the appropriate tabs of the Database Role Designer.
To create a new database role with modification as one of the existing database roles
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Database Role to open the Database Role showing the database role list.
- Select a database role to edit in the object pane.
- Control-click the database role and select Duplicate Database Role from the popup menu.
- Edit database role properties and privileges on the appropriate tabs of the Database Role Designer.
Edit Database Role
To edit an existing database role
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Database Role to open the Database Role showing the database role list.
- Select a database role to edit in the object pane.
- Click the
from the object pane toolbar or control-click the database role and select Design Database Role from the popup menu.
- Edit database role properties and permissions on the appropriate tabs of the Database Role Designer.
Delete Database Role
To delete a Database Role
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Database Role to open the Database Role showing the database role list.
- Select a database role to delete in the object pane.
- Click the
from the object pane toolbar or control-click the database role and select Delete Database Role from the popup menu.
- Confirm deleting in the dialog window.
Manage Application Role
Just simply click -> Application Role to open an object pane for Application Role. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete application roles.
Add Application Role
To add a new application role
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Application Role to open the Application Role showing the application role list.
- Click the
from the object pane toolbar or control-click and select New Application Role from the popup menu.
- Edit application role properties and permissions on the appropriate tabs of the Application Role Designer.
To create a new application role with modification as one of the existing application roles
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Application Role to open the Application Role showing the application role list.
- Select an application role to edit in the object pane.
- Control-click the application role and select Duplicate Application Role from the popup menu.
- Edit application role properties and privileges on the appropriate tabs of the Application Role Designer.
Edit Application Role
To edit an existing application role
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Application Role to open the Application Role showing the application role list.
- Select an application role to edit in the object pane.
- Click the
from the object pane toolbar or control-click the application role and select Design Application Role from the popup menu.
- Edit application role properties and permissions on the appropriate tabs of the Application Role Designer.
Delete Application Role
To delete an application role
- Select the connection you wish to set privileges in the navigation pane.
- Click
-> Application Role to open the Application Role showing the application role list.
- Select an application role to delete in the object pane.
- Click the
from the object pane toolbar or control-click the application role and select Delete Application Role from the popup menu.
- Confirm deleting in the dialog window.
Privilege Manager
To edit privilege according to the database objects by using Privilege Manager
- Select the connection you wish to set privileges in the navigation pane.
- Choose Connection -> Set Privileges or control-click the connection and select Set Privileges from the popup menu to open the Privilege Manager window and set privileges.